<?php
/**
* This file is part of the upgrade process.
*
* @package SendStudio
*/

/**
* Do a sanity check to make sure the upgrade api has been included.
*/
if (!class_exists('Upgrade_API', false)) {
	exit();
}

/**
* This class runs one change for the upgrade process.
* The Upgrade_API looks for a RunUpgrade method to call.
* That should return false for failure
* It should return true for success or if the change has already been made.
*
* @package SendStudio
*/
class list_subscribers_unsubscribe_create extends Upgrade_API
{
	/**
	* RunUpgrade
	* Runs the query for the upgrade process
	* and returns the result from the query.
	* The calling function looks for a true or false result
	*
	* @return Mixed Returns true if the condition is already met (eg the column already exists).
	*  Returns false if the database query can't be run.
	*  Returns the resource from the query (which is then checked to be true).
	*/
	function RunUpgrade()
	{
		$query = 'create table ' . SENDSTUDIO_TABLEPREFIX . 'list_subscribers_unsubscribe (
		  subscriberid int(11) NOT NULL default 0,
		  unsubscribetime int(11) NOT NULL default 0,
		  unsubscribeip varchar(20) default NULL,
		  unsubscriberequesttime int(11) default 0,
		  unsubscriberequestip varchar(20) default NULL,
		  listid int(11) NOT NULL default 0,
		  statid int(11) default 0,
		  unsubscribearea varchar(20) default NULL
		)';
		$result = $this->Db->Query($query);

		return $result;
	}
}
